﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace mitasoft.Common.Helpers
{
    public static class SqlScriptHelper
    {
        public static string SimpleJoin(string leftTable, string leftKey, string rightTable, string rightKey)
        {
            return string.Format(
                    @"select * from {0} as pc 
                        inner join {1} as ci 
                            on pc.{2} = ci.{3}", leftTable, rightKey, leftKey, rightKey);
        }

//         return @"select * from {0} as pc 
//                        inner join {1} as ci 
//                            on pc.{2} = ci.{3} 
//                      where PostId=@Id";
    }
}
